dopCases = [
    'batchcmd_delete_by_id_noindex.sql',
    'batchcmd_delete_by_id_serial.sql',
    'batchcmd_delete_by_idx_btree.sql',
    'batchcmd_delete_by_idx_noindex.sql',
    'batchcmd_delete_by_idx_primary.sql',
    'batchcmd_delete_by_idx_serial.sql',
    'batchcmd_insert_serial.sql',
    'batchcmd_update_id_by_idx_btree.sql',
    'batchcmd_update_id_by_idx_noindex.sql',
    'batchcmd_update_id_by_idx_primary.sql',
    'batchcmd_update_id_by_idx_serial.sql',
    'batchcmd_update_username_by_idx_btree.sql',
    'batchcmd_update_username_by_idx_noindex.sql',
    'batchcmd_update_username_by_idx_primary.sql',
    'batchcmd_update_username_by_idx_serial.sql',
    'batch_delete_by_id_noindex.sql',
    'batch_delete_by_id_serial.sql',
    'batch_delete_by_idx_btree.sql',
    'batch_delete_by_idx_noindex.sql',
    'batch_delete_by_idx_primary.sql',
    'batch_delete_by_idx_serial.sql',
    'batch_pbe_delete_by_id_noindex.sql',
    'batch_pbe_delete_by_id_serial.sql',
    'batch_pbe_delete_by_idx_btree.sql',
    'batch_pbe_delete_by_idx_noindex.sql',
    'batch_pbe_delete_by_idx_primary.sql',
    'batch_pbe_delete_by_idx_serial.sql',
    'batch_pbe_update_id_by_id_noindex.sql',
    'batch_pbe_update_id_by_id_serial.sql',
    'batch_pbe_update_id_by_idx_btree.sql',
    'batch_pbe_update_id_by_idx_noindex.sql',
    'batch_pbe_update_id_by_idx_primary.sql',
    'batch_pbe_update_id_by_idx_serial.sql',
    'batch_pbe_update_idx_by_id_noindex.sql',
    'batch_pbe_update_idx_by_id_serial.sql',
    'batch_pbe_update_username_by_id_noindex.sql',
    'batch_pbe_update_username_by_id_serial.sql',
    'batch_pbe_update_username_by_idx_btree.sql',
    'batch_pbe_update_username_by_idx_noindex.sql',
    'batch_pbe_update_username_by_idx_primary.sql',
    'batch_pbe_update_username_by_idx_serial.sql',
    'batch_update_id_by_id_noindex.sql',
    'batch_update_id_by_id_serial.sql',
    'batch_update_id_by_idx_btree.sql',
    'batch_update_id_by_idx_noindex.sql',
    'batch_update_id_by_idx_primary.sql',
    'batch_update_id_by_idx_serial.sql',
    'batch_update_idx_by_id_noindex.sql',
    'batch_update_idx_by_id_serial.sql',
    'batch_update_username_by_id_noindex.sql',
    'batch_update_username_by_id_serial.sql',
    'batch_update_username_by_idx_btree.sql',
    'batch_update_username_by_idx_noindex.sql',
    'batch_update_username_by_idx_primary.sql',
    'batch_update_username_by_idx_serial.sql',
    'sigle_delete_by_id_noindex.sql',
    'sigle_delete_by_id_serial.sql',
    'sigle_delete_by_idx_btree.sql',
    'sigle_delete_by_idx_multi.sql',
    'sigle_delete_by_idx_noindex.sql',
    'sigle_delete_by_idx_primary.sql',
    'sigle_delete_by_idx_serial.sql',
    'sigle_pbe_delete_by_id_noindex.sql',
    'sigle_pbe_delete_by_id_serial.sql',
    'sigle_pbe_delete_by_idx_btree.sql',
    'sigle_pbe_delete_by_idx_multi.sql',
    'sigle_pbe_delete_by_idx_noindex.sql',
    'sigle_pbe_delete_by_idx_primary.sql',
    'sigle_pbe_delete_by_idx_serial.sql',
    'sigle_pbe_insert_btree.sql',
    'sigle_pbe_insert_multi.sql',
    'sigle_pbe_insert_noindex.sql',
    'sigle_pbe_update_id_by_id_noindex.sql',
    'sigle_pbe_update_id_by_id_serial.sql',
    'sigle_pbe_update_id_by_idx_btree.sql',
    'sigle_pbe_update_id_by_idx_noindex.sql',
    'sigle_pbe_update_id_by_idx_primary.sql',
    'sigle_pbe_update_id_by_idx_serial.sql',
    'sigle_pbe_update_idx_by_id_noindex.sql',
    'sigle_pbe_update_idx_by_id_serial.sql',
    'sigle_pbe_update_username_by_id_noindex.sql',
    'sigle_pbe_update_username_by_id_serial.sql',
    'sigle_pbe_update_username_by_idx_btree.sql',
    'sigle_pbe_update_username_by_idx_noindex.sql',
    'sigle_pbe_update_username_by_idx_primary.sql',
    'sigle_pbe_update_username_by_idx_serial.sql',
    'sigle_update_id_by_id_noindex.sql',
    'sigle_update_id_by_id_serial.sql',
    'sigle_update_id_by_idx_btree.sql',
    'sigle_update_id_by_idx_noindex.sql',
    'sigle_update_id_by_idx_primary.sql',
    'sigle_update_id_by_idx_serial.sql',
    'sigle_update_idx_by_id_noindex.sql',
    'sigle_update_idx_by_id_serial.sql',
    'sigle_update_username_by_id_noindex.sql',
    'sigle_update_username_by_id_serial.sql',
    'sigle_update_username_by_idx_btree.sql',
    'sigle_update_username_by_idx_noindex.sql',
    'sigle_update_username_by_idx_primary.sql',
    'sigle_update_username_by_idx_serial.sql'
]
for caseName in dopCases:
    with open(caseName, 'r') as caseFile:
        oldContent = caseFile.read()

    with open(caseName, 'w') as caseFile:
        caseFile.write('set query_dop=4;\n\n')
        caseFile.write(oldContent)
        caseFile.write('\n\nset query_dop=1;\n')
